I agree with flipper about offering practical help. I would say, "If he is listening to anyone's prayers it would be yours, but I can listen and talk to you about what can be done to help and support you. He just might be trying to answer your prayers through others. I'm here for you."
Why make it a discussion about theology? To tell them prayer doesn't work is to crush their only source of comfort.